package nl.infodation.emr.pricingservice.dao;

import java.util.List;

import nl.infodation.emr.pricingservice.entity.SystemValueRole;

public interface SystemValueRoleDAO extends DAO<SystemValueRole, Integer> {

	public static final String FIND_SYTEM_VALUE_IDS_BY_ROLE = "SELECT p.systemValue.systemValueId" +
			" FROM SystemValueRole p INNER JOIN Role r" +
			" WHERE r.roleName=:roleName";
	
	/**
	 * Find list of SystemValue id
	 * @param roleName
	 * @return
	 */
	List<Integer> findIDsByRole(String roleName);
	
}
